package com.empire.module.spider.dal.mysql.lotteryfootballgamezucaisfc;

import java.util.*;

import com.empire.framework.common.pojo.PageResult;
import com.empire.framework.mybatis.core.query.LambdaQueryWrapperX;
import com.empire.framework.mybatis.core.mapper.BaseMapperX;
import com.empire.module.spider.dal.dataobject.lotteryfootballgamezucaisfc.LotteryFootballGameZucaiSfcDO;
import org.apache.ibatis.annotations.Mapper;
import com.empire.module.spider.controller.app.lotteryfootballgamezucaisfc.vo.*;

/**
 * 足彩胜负彩、任九比赛 Mapper
 *
 * @author 无敌
 */
@Mapper
public interface LotteryFootballGameZucaiSfcMapper extends BaseMapperX<LotteryFootballGameZucaiSfcDO> {

    default PageResult<LotteryFootballGameZucaiSfcDO> selectPage(AppLotteryFootballGameZucaiSfcPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<LotteryFootballGameZucaiSfcDO>()
                .eqIfPresent(LotteryFootballGameZucaiSfcDO::getGameNo, reqVO.getGameNo())
                .betweenIfPresent(LotteryFootballGameZucaiSfcDO::getStopTime, reqVO.getStopTime())
                .eqIfPresent(LotteryFootballGameZucaiSfcDO::getResult, reqVO.getResult())
                .eqIfPresent(LotteryFootballGameZucaiSfcDO::getExpect, reqVO.getExpect())
                .betweenIfPresent(LotteryFootballGameZucaiSfcDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(LotteryFootballGameZucaiSfcDO::getFid));
    }

}
